What is xSQL Builder?

xSQL Builder is a tool that allows you to automate the deployment of database-based solutions. It generates self-contained executable packages that provide for one click deployment of a SQL Server database to the clients’ environments regardless of whether it is a first time deployment or an upgrade from a previous version. The deployment package generated by the builder can be incorporated into a setup and deployment solution or it can be shipped to clients as a separate application.

xSQL Builder is an ideal tool for all software publishers who have deployed (or plan to) SQL Server based solutions to their clients. Often those clients are running different versions of the application and to make things more complicated in many cases some database customization work may have been performed for certain clients. In this scenario, deploying a new version of the application that involves structural (schema) changes on the database can be a nightmare – first the change scripts must account for the fact that clients have different versions of the database and second, the custom changes on each client's database must be preserved. Furthermore, the clients don’t usually have the necessary SQL Server expertise to safely deploy the database changes on their environment and the vendor, more often than not, does not have access to the client's environment so it is not possible to handle the upgrade from a central location. That is exactly what xSQL Builder has been designed to handle – the executable that is shipped to the client determines on the fly what changes need to be applied to each client's database by comparing it to a "master" database that is embedded in the package and the automatically applies those changes.